Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1175
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	617.4 KiB
Average record size in memory	538.0 B

Variable types

NUM	15
CAT	5
UNSUPPORTED	1

Reproduction

Analysis started	2021-03-27 17:01:53.098624
Analysis finished	2021-03-27 17:02:24.299713
Duration	31.2 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`title` has a high cardinality: 1168 distinct values	High cardinality
`deltaMedianPrice` is highly correlated with `deltaAvgPrice`	High correlation
`deltaAvgPrice` is highly correlated with `deltaMedianPrice`	High correlation
`dublinNorthSouth` is highly correlated with `neighbourhood`	High correlation
`neighbourhood` is highly correlated with `dublinNorthSouth`	High correlation
`title` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`floorArea` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`deltaMedianPrice` has 51 (4.3%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	1175
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1384.9131914893617
Minimum	0
Maximum	2818
Zeros	1
Zeros (%)	0.1%
Memory size	9.3 KiB

Quantile statistics

Minimum	0
5-th percentile	178.7
Q1	761
median	1385
Q3	1998.5
95-th percentile	2594.3
Maximum	2818
Range	2818
Interquartile range (IQR)	1237.5

Descriptive statistics

Standard deviation	757.2597258
Coefficient of variation (CV)	0.5467921964
Kurtosis	-1.05217277
Mean	1384.913191
Median Absolute Deviation (MAD)	620
Skewness	0.003204653992
Sum	1627273
Variance	573442.2923

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1	0.1%
1306	1	0.1%
1341	1	0.1%
1340	1	0.1%
1338	1	0.1%
2391	1	0.1%
1335	1	0.1%
1333	1	0.1%
1330	1	0.1%
2356	1	0.1%
Other values (1165)	1165	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
2	1	0.1%
4	1	0.1%
12	1	0.1%
13	1	0.1%

Value	Count	Frequency (%)
2818	1	0.1%
2817	1	0.1%
2815	1	0.1%
2809	1	0.1%
2800	1	0.1%

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1168
Unique (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

Apartment 406, Beacon One, Sandyford, Dublin 18	2
171 Drimnagh Road, Drimnagh, Dublin 12	2
20 Moyclare Road, Baldoyle, Dublin 13	2
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2
20 Muckross Green, Perrystown, Dublin 12	2
Other values (1163)	1165

Value	Count	Frequency (%)
Apartment 406, Beacon One, Sandyford, Dublin 18	2	0.2%
171 Drimnagh Road, Drimnagh, Dublin 12	2	0.2%
20 Moyclare Road, Baldoyle, Dublin 13	2	0.2%
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2	0.2%
20 Muckross Green, Perrystown, Dublin 12	2	0.2%
51 Grange Park, Rathfarnham, Dublin 14	2	0.2%
1 Fitzgibbon Lane, Dublin 1	2	0.2%
37 Saint Anne's Avenue, Raheny, Dublin 5	1	0.1%
Apartment 127, Rockview, Blackglen Road, Sandyford, Dublin 18	1	0.1%
52 Kildonan Avenue, Finglas West, Finglas, Dublin 11	1	0.1%
Other values (1158)	1158	98.6%

Length

Max length	84
Mean length	45.15829787
Min length	22

Value	Count	Frequency (%)
Lowercase_Letter	26	36.6%
Uppercase_Letter	25	35.2%
Decimal_Number	10	14.1%
Other_Punctuation	5	7.0%
Dash_Punctuation	1	1.4%
Space_Separator	1	1.4%
Math_Symbol	1	1.4%
Open_Punctuation	1	1.4%
Close_Punctuation	1	1.4%

Value	Count	Frequency (%)
Latin	51	71.8%
Common	20	28.2%

Value	Count	Frequency (%)
ASCII	71	100.0%

neighbourhood
Categorical

HIGH CORRELATION

Distinct count	22
Unique (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

Dublin 15	132
Dublin 11	92
Dublin 9	73
Dublin 8	71
Dublin 3	71
Other values (17)	736

Value	Count	Frequency (%)
Dublin 15	132	11.2%
Dublin 11	92	7.8%
Dublin 9	73	6.2%
Dublin 8	71	6.0%
Dublin 3	71	6.0%
Dublin 7	69	5.9%
Dublin 14	66	5.6%
Dublin 4	65	5.5%
Dublin 24	63	5.4%
Dublin 6	61	5.2%
Other values (12)	412	35.1%

Length

Max length	9
Mean length	8.561702128
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Lowercase_Letter	5	27.8%
Uppercase_Letter	2	11.1%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Common	11	61.1%
Latin	7	38.9%

Value	Count	Frequency (%)
ASCII	18	100.0%

propertyType
Categorical

Distinct count	9
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

Apartment	368
Terrace	313
Semi-D	236
End of Terrace	121
Detached	60
Other values (4)	77

Value	Count	Frequency (%)
Apartment	368	31.3%
Terrace	313	26.6%
Semi-D	236	20.1%
End of Terrace	121	10.3%
Detached	60	5.1%
Duplex	35	3.0%
Bungalow	15	1.3%
Townhouse	14	1.2%
Site	13	1.1%

Length

Max length	14
Mean length	8.17106383
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	19	70.4%
Uppercase_Letter	6	22.2%
Dash_Punctuation	1	3.7%
Space_Separator	1	3.7%

Value	Count	Frequency (%)
Latin	25	92.6%
Common	2	7.4%

Value	Count	Frequency (%)
ASCII	27	100.0%

numBedrooms
Real number (ℝ)

Distinct count	9
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.6
Minimum	-1.0
Maximum	11.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	11
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.008481916
Coefficient of variation (CV)	0.38787766
Kurtosis	5.690639839
Mean	2.6
Median Absolute Deviation (MAD)	1
Skewness	0.4592048756
Sum	3055
Variance	1.017035775

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	488	41.5%
2	423	36.0%
4	119	10.1%
1	98	8.3%
5	27	2.3%
-1	13	1.1%
6	4	0.3%
7	2	0.2%
11	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	13	1.1%
1	98	8.3%
2	423	36.0%
3	488	41.5%
4	119	10.1%

Value	Count	Frequency (%)
11	1	0.1%
7	2	0.2%
6	4	0.3%
5	27	2.3%
4	119	10.1%

numBathrooms
Real number (ℝ)

Distinct count	7
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.643404255319149
Minimum	-1.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.866559501
Coefficient of variation (CV)	0.5272953981
Kurtosis	1.42375293
Mean	1.643404255
Median Absolute Deviation (MAD)	1
Skewness	0.5840058131
Sum	1931
Variance	0.7509253688

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	583	49.6%
2	395	33.6%
3	149	12.7%
4	28	2.4%
-1	17	1.4%
5	2	0.2%
6	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	17	1.4%
1	583	49.6%
2	395	33.6%
3	149	12.7%
4	28	2.4%

Value	Count	Frequency (%)
6	1	0.1%
5	2	0.2%
4	28	2.4%
3	149	12.7%
2	395	33.6%

floorArea
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

price
Real number (ℝ_≥0)

Distinct count	179
Unique (%)	15.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	389606.8085106383
Minimum	75000.0
Maximum	2500000.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	75000
5-th percentile	195000
Q1	260000
median	335000
Q3	449000
95-th percentile	784500
Maximum	2500000
Range	2425000
Interquartile range (IQR)	189000

Descriptive statistics

Standard deviation	221596.5077
Coefficient of variation (CV)	0.5687695976
Kurtosis	23.12062082
Mean	389606.8085
Median Absolute Deviation (MAD)	85000
Skewness	3.634528448
Sum	457788000
Variance	4.910501222e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
275000	43	3.7%
395000	35	3.0%
375000	35	3.0%
350000	33	2.8%
295000	31	2.6%
225000	29	2.5%
250000	28	2.4%
425000	26	2.2%
450000	26	2.2%
285000	24	2.0%
Other values (169)	865	73.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
75000	1	0.1%
129000	1	0.1%
135000	1	0.1%
139000	1	0.1%
140000	3	0.3%

Value	Count	Frequency (%)
2500000	2	0.2%
2300000	1	0.1%
1800000	1	0.1%
1700000	1	0.1%
1600000	1	0.1%

rating
Categorical

Distinct count	16
Unique (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

D2	152
D1	138
C3	118
C2	114
C1	98
Other values (11)	555

Value	Count	Frequency (%)
D2	152	12.9%
D1	138	11.7%
C3	118	10.0%
C2	114	9.7%
C1	98	8.3%
B3	91	7.7%
E1	91	7.7%
E2	81	6.9%
F	70	6.0%
G	70	6.0%
Other values (6)	152	12.9%

Length

Max length	6
Mean length	2.060425532
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	10	66.7%
Decimal_Number	4	26.7%
Connector_Punctuation	1	6.7%

Value	Count	Frequency (%)
Latin	10	66.7%
Common	5	33.3%

Value	Count	Frequency (%)
ASCII	15	100.0%

sellerId
Real number (ℝ_≥0)

Distinct count	195
Unique (%)	16.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5787.916595744681
Minimum	7
Maximum	12149
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	7
5-th percentile	12
Q1	1367
median	6996
Q3	9917
95-th percentile	11062
Maximum	12149
Range	12142
Interquartile range (IQR)	8550

Descriptive statistics

Standard deviation	4274.074934
Coefficient of variation (CV)	0.7384479136
Kurtosis	-1.663292854
Mean	5787.916596
Median Absolute Deviation (MAD)	3953
Skewness	-0.1003230644
Sum	6800802
Variance	18267716.54

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11062	48	4.1%
10947	48	4.1%
7569	40	3.4%
11	37	3.1%
12	29	2.5%
1590	27	2.3%
3658	26	2.2%
1413	24	2.0%
10948	24	2.0%
9172	23	2.0%
Other values (185)	849	72.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	5	0.4%
11	37	3.1%
12	29	2.5%
49	15	1.3%
56	6	0.5%

Value	Count	Frequency (%)
12149	1	0.1%
12120	3	0.3%
11902	6	0.5%
11766	4	0.3%
11754	1	0.1%

longitude
Real number (ℝ)

Distinct count	1151
Unique (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-6.283536942141653
Minimum	-6.441123
Maximum	-6.055211
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	-6.441123
5-th percentile	-6.405139
Q1	-6.327493
median	-6.279775
Q3	-6.2362895
95-th percentile	-6.1681232
Maximum	-6.055211
Range	0.385912
Interquartile range (IQR)	0.0912035

Descriptive statistics

Standard deviation	0.07180332691
Coefficient of variation (CV)	-0.01142721489
Kurtosis	-0.1693690409
Mean	-6.283536942
Median Absolute Deviation (MAD)	0.044036
Skewness	-0.009598664888
Sum	-7383.155907
Variance	0.005155717755

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-6.371453	3	0.3%
-6.34301	2	0.2%
-6.309374	2	0.2%
-6.146247	2	0.2%
-6.25762	2	0.2%
-6.267336	2	0.2%
-6.355033	2	0.2%
-6.256604	2	0.2%
-6.374559	2	0.2%
-6.248074	2	0.2%
Other values (1141)	1154	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.441123	1	0.1%
-6.440657	1	0.1%
-6.440503	1	0.1%
-6.440373	1	0.1%
-6.439065	1	0.1%

Value	Count	Frequency (%)
-6.055211	1	0.1%
-6.059735	1	0.1%
-6.060574	1	0.1%
-6.065742	1	0.1%
-6.066756	1	0.1%

latitude
Real number (ℝ_≥0)

Distinct count	1146
Unique (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	53.34522645717897
Minimum	53.21904
Maximum	53.432174
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	53.21904
5-th percentile	53.270019
Q1	53.3184445
median	53.347615
Q3	53.381695
95-th percentile	53.4029602
Maximum	53.432174
Range	0.213134
Interquartile range (IQR)	0.0632505

Descriptive statistics

Standard deviation	0.04275896152
Coefficient of variation (CV)	0.0008015517856
Kurtosis	-0.6508129507
Mean	53.34522646
Median Absolute Deviation (MAD)	0.032662
Skewness	-0.4262771467
Sum	62680.64109
Variance	0.00182832879

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53.3188	3	0.3%
53.270541	2	0.2%
53.357853	2	0.2%
53.339611	2	0.2%
53.348851	2	0.2%
53.31296	2	0.2%
53.276203	2	0.2%
53.386451	2	0.2%
53.341431	2	0.2%
53.338922	2	0.2%
Other values (1136)	1154	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
53.21904	1	0.1%
53.226358	1	0.1%
53.229695	1	0.1%
53.231998	1	0.1%
53.233244	1	0.1%

Value	Count	Frequency (%)
53.432174	1	0.1%
53.431643	1	0.1%
53.422947	1	0.1%
53.422384	1	0.1%
53.422316	1	0.1%

pricePerBedroom
Real number (ℝ)

Distinct count	277
Unique (%)	23.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	145701.874366768
Minimum	-1500000.0
Maximum	625000.0
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	-1500000
5-th percentile	76666.66667
Q1	107142.8571
median	137500
Q3	185000
95-th percentile	275000
Maximum	625000
Range	2125000
Interquartile range (IQR)	77857.14286

Descriptive statistics

Standard deviation	105117.7109
Coefficient of variation (CV)	0.7214575058
Kurtosis	75.93107687
Mean	145701.8744
Median Absolute Deviation (MAD)	37500
Skewness	-5.743927508
Sum	171199702.4
Variance	1.104973314e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
150000	32	2.7%
125000	31	2.6%
175000	24	2.0%
187500	23	2.0%
100000	22	1.9%
115000	20	1.7%
112500	19	1.6%
137500	19	1.6%
91666.66667	19	1.6%
95000	18	1.5%
Other values (267)	948	80.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1500000	1	0.1%
-850000	2	0.2%
-775000	1	0.1%
-745000	1	0.1%
-498000	1	0.1%

Value	Count	Frequency (%)
625000	2	0.2%
600000	1	0.1%
460000	1	0.1%
450000	2	0.2%
437500	1	0.1%

deltaAvgPrice
Real number (ℝ)

HIGH CORRELATION

Distinct count	741
Unique (%)	63.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22239.894770579634
Minimum	-1794036.3636363638
Maximum	418361.1111111111
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	-1794036.364
5-th percentile	-257152.5258
Q1	-32567.98623
median	42361.11111
Q3	111124.02
95-th percentile	267361.1111
Maximum	418361.1111
Range	2212397.475
Interquartile range (IQR)	143692.0062

Descriptive statistics

Standard deviation	190988.8177
Coefficient of variation (CV)	8.587667327
Kurtosis	23.37589282
Mean	22239.89477
Median Absolute Deviation (MAD)	71776.03175
Skewness	-3.303256755
Sum	26131876.36
Variance	3.647672848e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
69137.14286	8	0.7%
79137.14286	6	0.5%
114137.1429	6	0.5%
-11633.02752	6	0.5%
74137.14286	6	0.5%
-85701.92308	6	0.5%
64298.07692	6	0.5%
86670.45455	6	0.5%
49137.14286	6	0.5%
56284.40367	6	0.5%
Other values (731)	1113	94.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1794036.364	2	0.2%
-1594036.364	1	0.1%
-1322050	1	0.1%
-1082638.889	1	0.1%
-1055862.857	1	0.1%

Value	Count	Frequency (%)
418361.1111	1	0.1%
415963.6364	1	0.1%
410963.6364	1	0.1%
396086.0215	1	0.1%
392361.1111	1	0.1%

deltaMedianPrice
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	304
Unique (%)	25.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-24545.957446808512
Minimum	-1997500.0
Maximum	374000.0
Zeros	51
Zeros (%)	4.3%
Memory size	9.3 KiB

Quantile statistics

Minimum	-1997500
5-th percentile	-333000
Q1	-61250
median	5000
Q3	70000
95-th percentile	175750
Maximum	374000
Range	2371500
Interquartile range (IQR)	131250

Descriptive statistics

Standard deviation	194272.3067
Coefficient of variation (CV)	-7.91463552
Kurtosis	29.93036674
Mean	-24545.95745
Median Absolute Deviation (MAD)	65000
Skewness	-4.094590967
Sum	-28841500
Variance	3.774172915e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	51	4.3%
5000	25	2.1%
50000	24	2.0%
10000	23	2.0%
-20000	21	1.8%
-15000	20	1.7%
55000	20	1.7%
70000	19	1.6%
15000	19	1.6%
75000	19	1.6%
Other values (294)	934	79.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1997500	2	0.2%
-1797500	1	0.1%
-1405000	1	0.1%
-1170000	1	0.1%
-1115000	1	0.1%

Value	Count	Frequency (%)
374000	1	0.1%
331000	1	0.1%
324000	1	0.1%
305000	1	0.1%
295000	2	0.2%

dublinNorthSouth
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	9.3 KiB

S	596
N	579

Value	Count	Frequency (%)
S	596	50.7%
N	579	49.3%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	2	100.0%

Value	Count	Frequency (%)
Latin	2	100.0%

Value	Count	Frequency (%)
ASCII	2	100.0%

distToCity
Real number (ℝ_≥0)

Distinct count	1152
Unique (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.068553655055304
Minimum	0.09991156306907832
Maximum	16.56325021500442
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	0.09991156307
5-th percentile	1.388228897
Q1	3.204927425
median	5.502717311
Q3	8.784903763
95-th percentile	12.0909124
Maximum	16.56325022
Range	16.46333865
Interquartile range (IQR)	5.579976338

Descriptive statistics

Standard deviation	3.469708067
Coefficient of variation (CV)	0.5717520622
Kurtosis	-0.6625336301
Mean	6.068553655
Median Absolute Deviation (MAD)	2.763996005
Skewness	0.4517911104
Sum	7130.550545
Variance	12.03887407

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8.438129316	3	0.3%
5.520706604	2	0.2%
5.229600299	2	0.2%
1.463954511	2	0.2%
2.213178012	2	0.2%
2.415355904	2	0.2%
8.239632795	2	0.2%
3.590435795	2	0.2%
10.21478363	2	0.2%
1.475217131	2	0.2%
Other values (1142)	1154	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09991156307	1	0.1%
0.1835478493	1	0.1%
0.2065863985	1	0.1%
0.3172734398	1	0.1%
0.346479514	1	0.1%

Value	Count	Frequency (%)
16.56325022	1	0.1%
16.24328956	1	0.1%
16.14727723	1	0.1%
15.94972834	1	0.1%
15.89190135	1	0.1%

daysSincePublished
Real number (ℝ_≥0)

Distinct count	157
Unique (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	70.49191489361702
Minimum	1
Maximum	367
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	30
median	66
Q3	107
95-th percentile	142
Maximum	367
Range	366
Interquartile range (IQR)	77

Descriptive statistics

Standard deviation	46.11907477
Coefficient of variation (CV)	0.6542463038
Kurtosis	0.9919174926
Mean	70.49191489
Median Absolute Deviation (MAD)	37
Skewness	0.6444218802
Sum	82828
Variance	2126.969057

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
82	31	2.6%
66	24	2.0%
102	23	2.0%
24	23	2.0%
67	22	1.9%
115	21	1.8%
114	21	1.8%
43	19	1.6%
95	19	1.6%
22	19	1.6%
Other values (147)	953	81.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.3%
2	6	0.5%
3	14	1.2%
4	16	1.4%
5	13	1.1%

Value	Count	Frequency (%)
367	1	0.1%
241	1	0.1%
238	2	0.2%
224	1	0.1%
220	1	0.1%

numFood
Real number (ℝ_≥0)

Distinct count	46
Unique (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	45.13106382978724
Minimum	11
Maximum	60
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	11
5-th percentile	29
Q1	42
median	47
Q3	50
95-th percentile	53
Maximum	60
Range	49
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.409408367
Coefficient of variation (CV)	0.1641753537
Kurtosis	2.063909171
Mean	45.13106383
Median Absolute Deviation (MAD)	4
Skewness	-1.399556958
Sum	53029
Variance	54.89933234

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
49	128	10.9%
50	113	9.6%
51	89	7.6%
45	80	6.8%
48	77	6.6%
47	74	6.3%
52	65	5.5%
46	60	5.1%
44	49	4.2%
53	46	3.9%
Other values (36)	394	33.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	1	0.1%
14	1	0.1%
15	1	0.1%
16	2	0.2%
18	1	0.1%

Value	Count	Frequency (%)
60	1	0.1%
59	1	0.1%
58	1	0.1%
57	1	0.1%
56	5	0.4%

numRecreation
Real number (ℝ_≥0)

Distinct count	23
Unique (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.897021276595744
Minimum	1
Maximum	24
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	9
median	12
Q3	15
95-th percentile	18
Maximum	24
Range	23
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.994517066
Coefficient of variation (CV)	0.3357577475
Kurtosis	-0.1638100472
Mean	11.89702128
Median Absolute Deviation (MAD)	3
Skewness	-0.328708574
Sum	13979
Variance	15.95616659

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	122	10.4%
13	121	10.3%
14	121	10.3%
11	111	9.4%
15	96	8.2%
16	84	7.1%
8	78	6.6%
10	77	6.6%
9	75	6.4%
17	63	5.4%
Other values (13)	227	19.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3	0.3%
2	7	0.6%
3	20	1.7%
4	46	3.9%
5	26	2.2%

Value	Count	Frequency (%)
24	2	0.2%
23	2	0.2%
21	3	0.3%
20	7	0.6%
19	20	1.7%

numShop
Real number (ℝ_≥0)

Distinct count	38
Unique (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.884255319148936
Minimum	1
Maximum	38
Zeros	0
Zeros (%)	0.0%
Memory size	9.3 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	6
median	8
Q3	18
95-th percentile	27
Maximum	38
Range	37
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.763335986
Coefficient of variation (CV)	0.6532454729
Kurtosis	0.2006646826
Mean	11.88425532
Median Absolute Deviation (MAD)	3
Skewness	1.029547918
Sum	13964
Variance	60.26938562

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	311	26.5%
7	107	9.1%
5	64	5.4%
8	54	4.6%
11	46	3.9%
18	46	3.9%
17	43	3.7%
20	39	3.3%
4	35	3.0%
9	35	3.0%
Other values (28)	395	33.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9	0.8%
2	15	1.3%
3	14	1.2%
4	35	3.0%
5	64	5.4%

Value	Count	Frequency (%)
38	1	0.1%
37	1	0.1%
36	3	0.3%
35	5	0.4%
34	3	0.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
0	0	170 Mount Garrett Park, Tyrellstown, Tyrrelstown, Dublin 15	Dublin 15	Apartment	2.0	2.0	65	200000.0	C1	1815	-6.392909	53.422384	100000.000000	144137.142857	85000.0	N	11.799143	9	32	5	20
1	2	Muir Cu, 6 Westwood Road, Finglas, Dublin 11	Dublin 11	End of Terrace	3.0	1.0	95	260000.0	E2	1815	-6.319989	53.384121	86666.666667	31284.403670	15000.0	N	5.364379	16	47	16	2
2	4	Apartment 35, Cloonlara Square, Phoenix Park Racecourse, Castleknock, Dublin 15	Dublin 15	Apartment	2.0	2.0	75	340000.0	B3	4274	-6.337658	53.373575	170000.000000	4137.142857	-55000.0	N	5.751517	9	40	10	13
3	12	6 Sycamore Avenue, Castleknock, Dublin 15	Dublin 15	Semi-D	3.0	1.0	94	390000.0	D1	1590	-6.387025	53.375988	130000.000000	-45862.857143	-105000.0	N	8.925828	5	44	9	23
4	13	5 Ellensborough Court, Kiltipper Road, Kiltipper, Dublin 24	Dublin 24	Semi-D	3.0	3.0	124	359000.0	C1	2608	-6.366592	53.268978	119666.666667	-76081.395349	-89000.0	S	11.805436	12	23	4	20
5	14	Apartment 5, Glenesky Square, Phoenix Park Racecourse, Castleknock, Dublin 15	Dublin 15	Apartment	3.0	2.0	86	340000.0	C3	12	-6.337871	53.372638	113333.333333	4137.142857	-55000.0	N	5.724247	1	40	10	13
6	16	677 Collins Avenue Extension, Whitehall, Dublin 9	Dublin 9	Semi-D	3.0	2.0	110	395000.0	D1	3658	-6.262782	53.388519	131666.666667	-11633.027523	-20000.0	N	3.948689	8	51	10	7
7	41	48 Pinewood Park, Rathfarnham, Dublin 14	Dublin 14	Semi-D	3.0	1.0	103	550000.0	E2	12149	-6.297046	53.289811	183333.333333	71086.021505	49000.0	S	7.495359	25	46	11	18
8	44	82 St. James Road, Walkinstown, Dublin 12	Dublin 12	Terrace	3.0	2.0	88	365000.0	D2	8647	-6.334378	53.313104	121666.666667	-47421.686747	-70000.0	S	6.741105	21	39	11	16
9	47	11 Old Farm, Carpenterstown Road, Castleknock, Dublin 15	Dublin 15	Apartment	1.0	2.0	51	195000.0	D2	7648	-6.393151	53.376222	195000.000000	149137.142857	90000.0	N	9.323000	16	43	9	23

Last rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
1165	2776	Apartment 62, Fitzwilliam Quay Apartments, Ringsend, Dublin 4	Dublin 4	Apartment	2.0	1.0	56	320000.0	D2	11062	-6.227004	53.340166	160000.000000	385963.636364	182500.0	S	2.508764	36	49	16	6
1166	2784	10 Shamrock Cottages, North Strand, Dublin 3	Dublin 3	Townhouse	2.0	1.0	49	200000.0	G	2050	-6.244140	53.355253	100000.000000	277950.000000	195000.0	N	0.949914	52	49	13	6
1167	2791	133 Kiltipper Gate, Tallaght, Dublin 24	Dublin 24	Apartment	2.0	2.0	70	215000.0	ZZZ	8210	-6.370672	53.269495	107500.000000	67918.604651	55000.0	S	11.927989	43	23	4	19
1168	2796	Winterbourne, Cruagh Road, Rathfarnham, Dublin 14	Dublin 14	Detached	4.0	2.0	163	595000.0	E2	49	-6.308844	53.242353	148750.000000	26086.021505	4000.0	S	12.761635	9	11	7	4
1169	2798	2 Florence Street, Portobello, Dublin 8	Dublin 8	Terrace	3.0	2.0	124	595000.0	E2	8456	-6.269723	53.331242	198333.333333	-255701.923077	-297500.0	S	2.550457	117	53	12	6
1170	2800	9 Saint Johns Court, Kilmore Road, Artane, Dublin 5	Dublin 5	Terrace	2.0	1.0	71	285000.0	C3	1063	-6.218931	53.390851	142500.000000	117608.247423	95000.0	N	4.930323	52	55	14	9
1171	2809	Apt 4, Slane House, Patrick Street, Christchurch, Dublin 8	Dublin 8	Apartment	1.0	1.0	37	230000.0	E2	6223	-6.272552	53.340047	230000.000000	109298.076923	67500.0	S	1.742339	30	53	8	6
1172	2815	4 Old Mount Pleasant, Ranelagh, Dublin 6	Dublin 6	Terrace	3.0	1.0	154	825000.0	SI_666	262	-6.258158	53.326563	275000.000000	-207638.888889	-295000.0	S	2.948946	31	53	15	7
1173	2817	10 Ard Na Greine, Eaton Brae, off Orwell Road, Rathgar, Dublin 6	Dublin 6	Terrace	2.0	2.0	144	900000.0	A3	9460	-6.261595	53.303673	450000.000000	-282638.888889	-370000.0	S	5.497794	75	50	17	9
1174	2818	3 Marian Drive, Rathfarnham, Dublin 14	Dublin 14	Detached	5.0	3.0	214	850000.0	C1	11062	-6.296157	53.295243	170000.000000	-228913.978495	-251000.0	S	6.910201	54	50	12	8

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows